Search TipsUnbilled Usage Analytics
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
| Subscription | Y | Numeric | 7,0 | CMP number for the subscription associated with the usage |
| Usage Date Time | Numeric | 25,0 | The date and time the usage took place. YYYY-MM-DD HH:MM:SS format | |
|
Network Code |
|
Alphanumeric |
6,0 |
CMP code for the network |
|
Usage Class |
|
Alphanumeric |
12,0 |
CMP code for the usage class, for example, DOMDATA |
|
Usage Class Description |
|
Alphanumeric |
30,0 |
Text description of the Usage Class code, for example, Domestic Data |
|
Company Number |
|
Numeric |
3 |
CMP ID number for the company |
|
Service Code |
|
Alphanumeric |
6,0 |
CMP Code for the pricing service associated with the usage, for example, EUDATA |
|
Service Description |
|
Alphanumeric |
30,0 |
Text description of the pricing service associated with the usage, for example, Euro Roaming Data |
|
Network Serial Number |
|
Numeric |
10,0 |
Serial number of the network associated with the usage |
|
Destination |
|
Numeric |
The dialled number | |
|
Actual Usage Units |
Numeric |
|
The actual amount of usage consumed, in units |
|
|
Billed Usage Units |
|
Numeric |
|
The amount of usage consumed, in units, that was invoiced for. |
|
Wholesale Charge |
|
Numeric |
11,4 |
The wholesale charge of the usage to 4 decimal places. |
|
Retail Charge |
|
Numeric |
11,4 |
The retail price of the usage to 4 decimal places. |
| Usage Status | Alphanumeric | The status of the usage | ||
|
Usage Type |
|
Numeric |
1 |
CMP code for the usage type |
|
Usage Type Description |
|
Alphanumeric |
30,0 |
Text description of the usage type |
|
Service Group |
|
Alphanumeric |
6,0 |
The CMP Code for the group to which the service belongs, for example, USAGE |
|
Service Group Description |
|
Alphanumeric |
30,0 |
Text description of the service group to which the service belongs, for example, Usage |
| Display on Invoice? | Alphanumeric | Whether to display the usage on the bill | ||
|
Pre-paid Units |
|
Numeric |
|
The amount of prepaid usage that was consumed, in units |
|
Pre-paid Duration |
|
Numeric |
|
The duration of the pre-paid usage |
|
Pre-paid Retail Price |
|
Numeric |
11,4 |
The retail price of the pre-paid usage, the amount to 4 decimal places |
| Usage Processed Date Time | Numeric | 12,0 | The date and time the usage records were processed. YYYY-MM-DD HH:MM:SS format | |
|
Access Charge |
|
Numeric |
11,4 |
If there is an access charge for the usage, the amount to 4 decimal places |
|
Service Charge |
Numeric |
11,4 |
If there is a charge for the service, the amount to 4 decimal places |
|
| Usage Direction | Alphanumeric | 2,0 | The code for the usage direction, either MO or MT | |
| Mobile Country Code | Numeric | 3,0 | 3-digit mobile telephone code for the country associated with the usage, for example 234 for United Kingdom | |
| Country Name | Alphanumeric | 30,0 | The name of the country associated with the mobile code, for example, Ireland for code 272 | |
| Mobile Network Operator | Numeric | 3,0 | The mobile telephone number code for the network operator associated with the usage, for example, 15 for Vodaphone | |
| Mobile Network Operator Name | Alphanumeric | 30,0 | The name of the network operator associated with the mobile network operator code | |
| Audit Timestamp | Numeric | 25,0 | The date and time of audit. YYYY-MM-DD HH:MM:SS format | |
| Audit User | Alphanumeric | User name of user who last changed data | ||
| Discount Value |
Numeric |
11,4 |
The value of any discount applied to the unbilled usage | |
| Data Extract Date | Numeric | 7,0 | Date and time this extract was created. YYYY-MM-DD format |